package jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {
//    public static void main(String[] args) {
//        try ( Connection connection=DBUtil.getConnection();){
//
//            Statement statement=connection.createStatement();
//            String sql="DELETE FROM userinfo"+" WHERE username='王洋'";
//            System.out.println(sql);
//            int num=statement.executeUpdate(sql);
//            if (num<=0){
//                System.out.println("删除失败");
//            }else {
//                System.out.println("删除成功");
//            }
//
//        } catch (SQLException e) {
//            throw new RuntimeException(e);
//        }
//
//    }
public static void main(String[] args) {
    UserInfo userInfo=InputUtil.getInputObject(new UserInfo(),"删除用户","删除");
    System.out.println(userInfo);
     try ( Connection connection=DBUtil.getConnection();){
        Statement statement=connection.createStatement();
        String sql="DELETE FROM userinfo"+" WHERE username='"+userInfo.getUsername()+"'";
        int num=statement.executeUpdate(sql);
         System.out.println("删除"+(num>0?"成功":"失败"));
     } catch (Exception e){
         e.printStackTrace();
     }
}
}
